package InterFace;
import pojo.*;
import java.sql.SQLException;
import java.util.List;

public interface SQL_Readin_api {
    String[] readClassID();
    Boolean userSign(String number, String password,String classId, String table);
    String userLog(String number, String password, String table) throws SQLException;
    List<ClassMember> readPeople(String className) throws SQLException;
    boolean deleteClassMember(String number) throws SQLException;
    boolean addClassMember(ClassMember classMember) throws SQLException;
    boolean updateClassMember(ClassMember classMember) throws SQLException;
    List<CommitteeMember> readUnit(String className) throws SQLException;
    Boolean addConmmitteeMemeber(CommitteeMember committeeMember) throws SQLException;
    Boolean deleteCommitteeStuById(String number) throws SQLException;
    List<DutySchedule> readDuty(String className) throws SQLException;
    boolean deleteDutyById(String number) throws SQLException;
    boolean addDutyStu (DutySchedule dutySchedule) throws SQLException;
    List<ExpenseRecord> readMoney(String className) throws SQLException , ClassNotFoundException;
    boolean addExpenseMoney(ExpenseRecord expenseRecord) throws SQLException;
    boolean deleteMoneyExpense(String s) throws SQLException;
    List<MessageBoard> readMessage(String className) throws SQLException;
    boolean addMessageBoard(MessageBoard messageBoard) throws SQLException;
    boolean deleteMessageBoard(String s) throws SQLException;
    List<ActivityRecord> getAllActivity(String className) throws SQLException;
    boolean deleteActivityById(Integer id) throws SQLException;
    boolean addActivity(ActivityRecord activityRecord) throws SQLException;
    boolean deleteRePun(int s) throws SQLException;
    List<RewardPunishmentRecord> readRePun(String className) throws SQLException;
    boolean addRewardPun(RewardPunishmentRecord rePunRecord);

}
